Overview
Use this application to import actual wage costs for a week from a CSV file. Typically the CSV file will be exported from a payroll solution. This value is then used in some reports for Wage % Sales reporting.
Show Example Row SC118,2005-05-15,1500.98
Additional Information
The CSV file must have the following structure: -
| Column | Value |
|---|---|
| Store Code | Specifies the store code (i.e. the Store.store_code) for the store. |
| Week Beginning | Specifies the week beginning date in the format of yyyy-mm-dd |
| Value | Specifies the numeric value of wages |
Once the report is run, it will show a message saying whether the import has completed successfully.
If values already exist in the database in the date range, but the CSV is sparse, i.e. doesn't contain values for those entries, the report will present the user with the option to:
- Set the targets on the existing rows to ZERO,
- Leave the targets intact, and proceed with importing the other values, or
- Cancel the import completely, making no changes to the database.
Generally option 1 will be appropriate, because the CSV will represent a complete section of data; however in advanced import cases the user might want to merge the CSV with the database data using option 2.